<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<META http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>Index</title>
<link type="text/css" href="../../skin/page.css" rel="stylesheet">
</head>
<body text="#000000" bgcolor="#FFFFFF">
<!--================= start Navigation Path ==================-->
<table summary="navigation path" width="100%" border="0" cellpadding="0" cellspacing="0">
<tr>
<td nowrap="nowrap" valign="middle" bgcolor="#CFDCED" height="20"><img height="1" width="5" alt="" src="../../skin/images/spacer.gif" class="spacer"><!--===== breadcrumb trail (javascript-generated) ====--><font size="2" face="Arial, Helvetica, Sans-serif"><script src="../../skin/breadcrumbs.js" language="JavaScript" type="text/javascript"></script></font></td>
</tr>
<tr>
<td bgcolor="#4C6C8F" height="2"><img height="2" width="2" alt="" src="../../skin/images/spacer.gif" class="spacer"></td>
</tr>
</table>
<!--================= end Navigation Path ==================-->
<!--================= start Banner ==================-->
<table summary="header with logos" width="100%" border="0" cellpadding="0" cellspacing="0">
<tr>
<!--================= start Group Logo ==================-->
<td bgcolor="#294563"><a href="http://incubator.apache.org"><img border="0" class="logoImage" alt="" src="../../resources/images/apache-incubator.png" title="Derby is a zero admin java based embedded database."></a></td>
<!--================= end Group Logo ==================-->
<!--================= start Project Logo ==================--><td width="100%" align="center" bgcolor="#294563"><a href="http://incubator.apache.org/derby/"><img border="0" class="logoImage" alt="Derby" src="../../images/derby-logo.jpg" title="Derby is a zero admin java based embedded database."></a></td>
<!--================= end Project Logo ==================-->
<!--================= start Search ==================--><td valign="top" rowspan="2" bgcolor="#294563">
<form target="_blank" action="http://www.google.com/search" method="get">
<table summary="search" border="0" cellspacing="0" cellpadding="0" bgcolor="#4C6C8F">
<tr>
<td colspan="3"><img height="10" width="1" alt="" src="../../skin/images/spacer.gif" class="spacer"></td>
</tr>
<tr>
<td><img height="1" width="1" alt="" src="../../skin/images/spacer.gif" class="spacer"></td><td nowrap="nowrap"><input value="incubator.apache.org" name="sitesearch" type="hidden"><input size="15" name="q" id="query" type="text"><img height="1" width="5" alt="" src="../../skin/images/spacer.gif" class="spacer"><input name="Search" value="Search" type="submit">
<br>
<font face="Arial, Helvetica, Sans-serif" size="2" color="white">
                      the Derby site
                      
                      
                    </font></td><td><img height="1" width="1" alt="" src="../../skin/images/spacer.gif" class="spacer"></td>
</tr>
<tr>
<td><img alt="" border="0" height="10" width="9" src="../../skin/images/search-left.gif"></td><td><img height="1" width="1" alt="" src="../../skin/images/spacer.gif" class="spacer"></td><td><img alt="" border="0" height="10" width="9" src="../../skin/images/search-right.gif"></td>
</tr>
</table>
</form>
</td>
<!--================= start Search ==================--><td bgcolor="#294563"><img height="10" width="10" alt="" src="../../skin/images/spacer.gif" class="spacer"></td>
</tr>
<tr>
<td valign="bottom" bgcolor="#294563" colspan="2">
<!--================= start Tabs ==================-->
<div class="tab">
<table summary="tab bar" border="0" cellpadding="0" cellspacing="0">
<tr>
<td width="6"><img alt="" height="8" width="6" src="../../skin/images/spacer.gif"></td><td valign="bottom">
<table summary="non selected tab" style="height: 1.6em" border="0" cellpadding="0" cellspacing="0">
<tr>
<td valign="top" width="5" bgcolor="#B2C4E0"><img height="5" width="5" alt="" src="../../skin/images/tab-left.gif"></td><td valign="middle" bgcolor="#B2C4E0"><a class="base-not-selected" href="../../index.html">Home</a></td><td valign="top" width="5" bgcolor="#B2C4E0"><img height="5" width="5" alt="" src="../../skin/images/tab-right.gif"></td>
</tr>
<tr>
<td colspan="3" height="1"></td>
</tr>
</table>
</td><td width="6"><img alt="" height="8" width="6" src="../../skin/images/spacer.gif"></td><td valign="bottom">
<table summary="selected tab" style="height: 1.8em" border="0" cellpadding="0" cellspacing="0">
<tr>
<td valign="top" width="5" bgcolor="#4C6C8F"><img height="5" width="5" alt="" src="../../skin/images/tabSel-left.gif"></td><td valign="middle" bgcolor="#4C6C8F"><font color="#ffffff" size="2" face="Arial, Helvetica, Sans-serif"><b><a class="base-selected" href="../../manuals/index.html">Manuals</a></b></font></td><td valign="top" width="5" bgcolor="#4C6C8F"><img height="5" width="5" alt="" src="../../skin/images/tabSel-right.gif"></td>
</tr>
</table>
</td><td width="6"><img alt="" height="8" width="6" src="../../skin/images/spacer.gif"></td><td valign="bottom">
<table summary="non selected tab" style="height: 1.6em" border="0" cellpadding="0" cellspacing="0">
<tr>
<td valign="top" width="5" bgcolor="#B2C4E0"><img height="5" width="5" alt="" src="../../skin/images/tab-left.gif"></td><td valign="middle" bgcolor="#B2C4E0"><a class="base-not-selected" href="../../papers/index.html">Papers</a></td><td valign="top" width="5" bgcolor="#B2C4E0"><img height="5" width="5" alt="" src="../../skin/images/tab-right.gif"></td>
</tr>
<tr>
<td colspan="3" height="1"></td>
</tr>
</table>
</td>
</tr>
</table>
</div>
<!--================= end Tabs ==================-->
</td><td bgcolor="#294563"><img alt="" width="1" height="1" src="../../skin/images/spacer.gif" class="spacer"></td>
</tr>
<tr>
<td bgcolor="#4C6C8F" colspan="4"><img width="1" height="10" alt="" src="../../skin/images/spacer.gif" class="spacer"></td>
</tr>
</table>
<!--================= end Banner ==================-->
<!--================= start Menu, NavBar, Content ==================-->
<table summary="page content" bgcolor="#ffffff" width="100%" border="0" cellpadding="0" cellspacing="0">
<tr>
<td valign="top">
<table summary="menu" border="0" cellspacing="0" cellpadding="0">
<tr>
<!--================= start left top NavBar ==================-->
<td rowspan="3" valign="top">
<table summary="blue line" border="0" cellpadding="0" cellspacing="0">
<tr>
<td bgcolor="#294563"><img width="10" height="1" alt="" src="../../skin/images/spacer.gif" class="spacer"></td>
</tr>
<tr>
<td bgcolor="#CFDCED"><font color="#4C6C8F" size="4" face="Arial, Helvetica, Sans-serif">&nbsp;</font></td>
</tr>
<tr>
<td bgcolor="#294563"><img width="10" height="1" alt="" src="../../skin/images/spacer.gif" class="spacer"></td>
</tr>
</table>
</td>
<!--================= end left top NavBar ==================--><td bgcolor="#294563"><img width="1" height="1" alt="" src="../../skin/images/spacer.gif" class="spacer"></td><td valign="bottom" bgcolor="#4C6C8F"><img width="10" height="10" alt="" src="../../skin/images/spacer.gif" class="spacer"></td><td nowrap="nowrap" valign="top" bgcolor="#4C6C8F">
<!--================= start Menu items ==================-->
<div class="menu">
<ul>
<li>
<font color="#CFDCED">Manuals</font>
<ul>
     
<li>
<a href="../../manuals/index.html">About</a>
</li>
     
<li>
<font color="#CFDCED">Getting Started</font>
<ul>
         
<li>
<a href="../../manuals/getstart/gspr02.html" title="Table of Contents">Table of Contents</a>
</li>
         
<li>
<a href="../../manuals/getstart/gspr40.html" title="Index">Index</a>
</li>
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
     
</ul>
</li>
     
<li>
<font color="#CFDCED">Reference Manual</font>
<ul>
         
<li>
<a href="../../manuals/reference/sqlj02.html" title="Table of Contents">Table of Contents</a>
</li>
         
<li>
<a href="../../manuals/reference/sqlj275.html" title="Index">Index</a>
</li>
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
     
</ul>
</li>

     
<li>
<font color="#CFDCED">Developer's Guide</font>
<ul>
         
<li>
<a href="../../manuals/develop/develop02.html" title="Table of Contents">Table of Contents</a>
</li>
         
<li>
<a href="../../manuals/develop/develop157.html" title="Index">Index</a>
</li>
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
     
</ul>
</li>
     
<li>
<font color="#CFDCED">Tuning Derby</font>
<ul>
         
<li>
<a href="../../manuals/tuning/perf02.html" title="Table of Contents">Table of Contents</a>
</li>
         
<li>
<span class="sel"><font color="#ffcc00">Index</font></span>
</li>
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
     
</ul>
</li>

     
<li>
<font color="#CFDCED">Server &amp; Admin Guide</font>
<ul>
         
<li>
<a href="../../manuals/admin/hubprnt02.html" title="Table of Contents">Table of Contents</a>
</li>
         
<li>
<a href="../../manuals/admin/hubprnt65.html" title="Index">Index</a>
</li>
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
        
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
    
</ul>
</li>

    
<li>
<font color="#CFDCED">Tools &amp; Utility Guide</font>
<ul>
         
<li>
<a href="../../manuals/tools/tools02.html" title="Table of Contents">Table of Contents</a>
</li>
         
<li>
<a href="../../manuals/tools/tools113.html" title="Index">Index</a>
</li>
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
    
</ul>
</li>
  
</ul>
</li>
</ul>
</div>
<!--================= end Menu items ==================-->
</td><td valign="bottom" bgcolor="#4C6C8F"><img width="10" height="10" alt="" src="../../skin/images/spacer.gif" class="spacer"></td><td bgcolor="#294563"><img width="1" height="1" alt="" src="../../skin/images/spacer.gif" class="spacer"></td>
</tr>
<tr>
<td valign="bottom" align="left" colspan="2" rowspan="2" bgcolor="#4C6C8F"><img height="10" width="10" border="0" alt="" src="../../skin/images/menu-left.gif"></td><td bgcolor="#4C6C8F"><img height="10" width="10" alt="" src="../../skin/images/spacer.gif" class="spacer"></td><td valign="bottom" align="right" colspan="2" rowspan="2" bgcolor="#4C6C8F"><img height="10" width="10" border="0" alt="" src="../../skin/images/menu-right.gif"></td>
</tr>
<tr>
<td height="1" bgcolor="#294563"><img width="1" height="1" alt="" src="../../skin/images/spacer.gif" class="spacer"></td>
</tr>
</table>
</td><td valign="top" width="100%">
<table summary="content" width="100%" border="0" cellpadding="0" cellspacing="0">
<!--================= start middle NavBar ==================-->
<tr>
<td colspan="4" bgcolor="#294563"><img width="10" height="1" alt="" src="../../skin/images/spacer.gif" class="spacer"></td>
</tr>
<tr>
<td align="left" width="10" bgcolor="#CFDCED"><img width="10" height="1" alt="" src="../../skin/images/spacer.gif" class="spacer"></td><td align="left" width="50%" bgcolor="#CFDCED"><font color="#4C6C8F" size="3" face="Arial, Helvetica, Sans-serif">
                &nbsp;
                
                </font><img width="10" height="8" alt="" src="../../skin/images/spacer.gif" class="spacer"></td><td align="right" width="50%" bgcolor="#CFDCED"><font color="#4C6C8F" size="3" face="Arial, Helvetica, Sans-serif">
                &nbsp;
                
                </font><img width="10" height="8" alt="" src="../../skin/images/spacer.gif" class="spacer"></td><td width="10" bgcolor="#CFDCED"><img width="10" height="1" alt="" src="../../skin/images/spacer.gif" class="spacer"></td>
</tr>
<tr>
<td colspan="4" bgcolor="#294563"><img width="10" height="1" alt="" src="../../skin/images/spacer.gif" class="spacer"></td>
</tr>
<!--================= end middle NavBar ==================-->
<!--================= start Content==================-->
<tr>
<td align="left" width="10"><img width="10" height="1" alt="" src="../../skin/images/spacer.gif" class="spacer"></td><td colspan="2" align="left" width="100%">
<div class="content">
<table class="title" summary="">
<tr>
<td valign="middle">
<h1>Index</h1>
</td>
</tr>
</table>
<ul class="minitoc">
<li>
<a href="#Index">Index</a>
</li>
</ul>
<a name="N10036"></a><a name="Index"></a>
<h3>Index</h3>
<div style="margin-left: 0 ; border: 2px">
<strong><a href="#IDX0_41">A</a></strong>
<ul>
<li>Access path <ul>
<li>how optimizer chooses <a href="perf45.html#IDX482">(482)</a>
</li>
<li>when optimizer's cost estimates for it are accurate <a href="perf55.html#IDX505">(505)</a>
</li>
</ul>
</li>
<li>Application design <ul>
<li>performance implications <a href="perf32.html#IDX427">(427)</a>
</li>
</ul>
</li>
<li>Application performance <ul>
<li>analyzing <a href="perf36.html#IDX446">(446)</a>
</li>
</ul>
</li>
<li>Authentication <ul>
<li>turning on <a href="perf70.html#IDX527">(527)</a>
</li>
</ul>
</li>
<li>Authentication provider <ul>
<li>specifying <a href="perf68.html#IDX522">(522)</a>
</li>
</ul>
</li>
</ul>
<strong><a href="#IDX0_42">B</a></strong>
<ul>
<li>Base table <ul>
<li>definition <a href="perf93.html#IDX573">(573)</a>
</li>
</ul>
</li>
<li>BETWEEN transformations <a href="perf95.html#IDX582">(582)</a>
</li>
<li>Bulk fetch <a href="perf45.html#IDX494">(494)</a> 
<ul>
<li>how optimizer chooses <a href="perf45.html#IDX493">(493)</a>
</li>
</ul>
</li>
</ul>
<strong><a href="#IDX0_43">C</a></strong>
<ul>
<li>Caches <ul>
<li>performance benefits of priming <a href="perf23.html#IDX411">(411)</a>
</li>
</ul>
</li>
<li>Cardinality statistics <a href="perf52.html#IDX502">(502)</a> 
<ul>
<li>definition <a href="perf57.html#IDX510">(510)</a>
</li>
<li>stale <a href="perf60.html#IDX512">(512)</a>
</li>
<li>working with <a href="perf58.html#IDX511">(511)</a>
</li>
</ul>
</li>
<li>Checkpoint <a href="perf36.html#IDX447">(447)</a>
</li>
<li>Class loading <ul>
<li>how to minimize impact of <a href="perf35.html#IDX442">(442)</a>
</li>
<li>tuning <a href="perf27.html#IDX423">(423)</a>
</li>
<li>when it occurs in Derby <a href="perf35.html#IDX441">(441)</a>
</li>
</ul>
</li>
<li>Class path <ul>
<li>performance implications of <a href="perf30.html#IDX425">(425)</a>
</li>
</ul>
</li>
<li>derby.authentication.ldap.searchAuthDN <a href="perf64.html#IDX513">(513)</a>
</li>
<li>derby.authentication.ldap.searchAuthPW <a href="perf65.html#IDX515">(515)</a>
</li>
<li>derby.authentication.ldap.searchbase <a href="perf66.html#IDX517">(517)</a>
</li>
<li>derby.authentication.ldap.searchfilter <a href="perf67.html#IDX519">(519)</a>
</li>
<li>derby.authentication.provider <a href="perf68.html#IDX521">(521)</a>
</li>
<li>derby.authentication.server <a href="perf69.html#IDX523">(523)</a>
</li>
<li>derby.connection.requireAuthentication <a href="perf70.html#IDX526">(526)</a>
</li>
<li>derby.database.defaultConnectionMode <a href="perf71.html#IDX529">(529)</a>
</li>
<li>derby.database.forceDatabaseLock <a href="perf72.html#IDX531">(531)</a>
</li>
<li>derby.database.fullAccessUsers <a href="perf73.html#IDX532">(532)</a>
</li>
<li>derby.database.noAutoBoot <a href="perf27.html#IDX422">(422)</a>
</li>
<li>derby.database.propertiesOnly <a href="perf11.html#IDX388">(388)</a>, <a href="perf74.html#IDX534">(534)</a>
</li>
<li>derby.database.readOnlyAccessUsers <a href="perf75.html#IDX536">(536)</a>
</li>
<li>derby.infolog.append <a href="perf76.html#IDX538">(538)</a>
</li>
<li>derby.language.logStatementText <a href="perf77.html#IDX540">(540)</a>
</li>
<li>derby.locks.deadlockTimeout <a href="perf78.html#IDX543">(543)</a>
</li>
<li>derby.locks.deadlockTrace <a href="perf79.html#IDX545">(545)</a>
</li>
<li>derby.locks.escalationThreshold <a href="perf45.html#IDX492">(492)</a>, <a href="perf80.html#IDX547">(547)</a>
</li>
<li>derby.locks.monitor <a href="perf81.html#IDX549">(549)</a>
</li>
<li>derby.locks.waitTimeout <a href="perf82.html#IDX552">(552)</a>
</li>
<li>Derby properties <ul>
<li>setting <a href="perf13.html#IDX394">(394)</a>
</li>
</ul>
</li>
<li>derby.properties file <a href="perf14.html#IDX395">(395)</a>, <a href="perf14.html#IDX400">(400)</a>
</li>
<li>derby.storage.initialPages <a href="perf83.html#IDX554">(554)</a>
</li>
<li>derby.storage.minimumRecordSize <a href="perf84.html#IDX556">(556)</a>
</li>
<li>derby.storage.pageCacheSize <a href="perf85.html#IDX557">(557)</a>
</li>
<li>derby.storage.pageReservedSpace <a href="perf86.html#IDX559">(559)</a>
</li>
<li>derby.storage.pageSize <a href="perf24.html#IDX412">(412)</a>, <a href="perf87.html#IDX561">(561)</a>
</li>
<li>derby.storage.tempDirectory <a href="perf88.html#IDX563">(563)</a>
</li>
<li>derby.stream.error.file <a href="perf89.html#IDX565">(565)</a>
</li>
<li>derby.stream.error.logSeverityLevel <a href="perf90.html#IDX567">(567)</a>
</li>
<li>derby.system.bootAll <a href="perf27.html#IDX421">(421)</a>
</li>
<li>derby.system.home <a href="perf91.html#IDX569">(569)</a> 
<ul>
<li>determining location of derby.properties <a href="perf14.html#IDX402">(402)</a>
</li>
</ul>
</li>
<li>derby.user <a href="perf92.html#IDX570">(570)</a>
</li>
<li>Compilation <ul>
<li>avoiding by using PreparedStatements <a href="perf34.html#IDX438">(438)</a>
</li>
<li>performance hit <a href="perf34.html#IDX437">(437)</a>
</li>
</ul>
</li>
<li>Configuring Derby <a href="perf13.html#IDX393">(393)</a>
</li>
<li>Covering indexes <a href="perf43.html#IDX468">(468)</a>
</li>
</ul>
<strong><a href="#IDX0_44">D</a></strong>
<ul>
<li>Data page cache <ul>
<li>performance benefits of increasing <a href="perf23.html#IDX410">(410)</a>
</li>
</ul>
</li>
<li>Database design <ul>
<li>performance implications <a href="perf32.html#IDX426">(426)</a>
</li>
</ul>
</li>
<li>Database pages <ul>
<li>preallocating <a href="perf83.html#IDX555">(555)</a>
</li>
</ul>
</li>
<li>Database-wide properties <ul>
<li>protecting against overrides <a href="perf74.html#IDX535">(535)</a>
</li>
<li>protecting for embedded environment <a href="perf11.html#IDX389">(389)</a>
</li>
<li>setting <a href="perf15.html#IDX403">(403)</a>
</li>
<li>verifying value of <a href="perf15.html#IDX405">(405)</a>
</li>
</ul>
</li>
<li>Deadlocks <ul>
<li>monitoring <a href="perf81.html#IDX551">(551)</a>
</li>
<li>timeout property <a href="perf78.html#IDX544">(544)</a>
</li>
<li>tracing <a href="perf79.html#IDX546">(546)</a>
</li>
<li>wait timeout property <a href="perf82.html#IDX553">(553)</a>
</li>
</ul>
</li>
<li>Derived tables <ul>
<li>definition <a href="perf93.html#IDX574">(574)</a>
</li>
</ul>
</li>
<li>Descending indexes <a href="perf33.html#IDX431">(431)</a>
</li>
<li>DISTINCT <ul>
<li>combined with ORDER BY <a href="perf115.html#IDX606">(606)</a>
</li>
<li>eliminated for uniqueness condition <a href="perf114.html#IDX605">(605)</a>
</li>
</ul>
</li>
<li>Dynamic properties <a href="perf12.html#IDX391">(391)</a>
</li>
</ul>
<strong><a href="#IDX0_45">E</a></strong>
<ul>
<li>Equality predicate <ul>
<li>definition <a href="perf93.html#IDX575">(575)</a>
</li>
</ul>
</li>
<li>Equijoin predicate <ul>
<li>definition <a href="perf93.html#IDX576">(576)</a>
</li>
</ul>
</li>
<li>Equijoins <ul>
<li>optimizable <a href="perf44.html#IDX479">(479)</a>
</li>
</ul>
</li>
<li>Error log <ul>
<li>configuring severity of errors that appear in <a href="perf90.html#IDX568">(568)</a>
</li>
<li>specifying file name <a href="perf89.html#IDX566">(566)</a>
</li>
</ul>
</li>
<li>EXISTS join <ul>
<li>definition <a href="perf108.html#IDX600">(600)</a>
</li>
</ul>
</li>
<li>Expensive queries <ul>
<li>how to avoid <a href="perf33.html#IDX436">(436)</a>
</li>
<li>importance of avoiding <a href="perf33.html#IDX435">(435)</a>
</li>
</ul>
</li>
</ul>
<strong><a href="#IDX0_46">F</a></strong>
<ul>
<li>FLOAT <ul>
<li>java.sql type converted to DOUBLE PRECISION when retrieved <a href="perf26.html#IDX418">(418)</a>
</li>
</ul>
</li>
</ul>
<strong><a href="#IDX0_48">H</a></strong>
<ul>
<li>Hash join strategy <a href="perf44.html#IDX476">(476)</a>
</li>
<li>Hash joins <ul>
<li>requirements for <a href="perf44.html#IDX477">(477)</a>
</li>
<li>use of memory <a href="perf44.html#IDX480">(480)</a>
</li>
</ul>
</li>
</ul>
<strong><a href="#IDX0_49">I</a></strong>
<ul>
<li>IN/ANY subquery transformation <a href="perf111.html#IDX602">(602)</a>
</li>
<li>Index order <ul>
<li>performance implications of <a href="perf33.html#IDX432">(432)</a>
</li>
</ul>
</li>
<li>Index use <ul>
<li>analyzing <a href="perf33.html#IDX430">(430)</a>, <a href="perf36.html#IDX444">(444)</a>
</li>
<li>how optimizer chooses <a href="perf45.html#IDX483">(483)</a>
</li>
</ul>
</li>
<li>Indexes <ul>
<li>cost of maintaining <a href="perf43.html#IDX470">(470)</a>
</li>
<li>definition <a href="perf43.html#IDX457">(457)</a>
</li>
<li>how they work <a href="perf42.html#IDX455">(455)</a>
</li>
<li>performance benefits of <a href="perf22.html#IDX409">(409)</a>, <a href="perf33.html#IDX429">(429)</a>
</li>
<li>when they are useful <a href="perf43.html#IDX458">(458)</a>
</li>
</ul>
</li>
<li>Indexes with Descending Ordering <ul>
<li>performance benefits of <a href="perf33.html#IDX434">(434)</a>
</li>
</ul>
</li>
<li>Information log <ul>
<li>overwriting <a href="perf76.html#IDX539">(539)</a>
</li>
</ul>
</li>
<li>Internal transformation of statements <a href="perf43.html#IDX466">(466)</a> 
<ul>
<li>BETWEEN predicates <a href="perf95.html#IDX583">(583)</a>
</li>
<li>COUNT <a href="perf118.html#IDX608">(608)</a>
</li>
<li>LIKE predicates <a href="perf96.html#IDX585">(585)</a>
</li>
<li>OR predicates <a href="perf98.html#IDX589">(589)</a>
</li>
<li>predicates <a href="perf94.html#IDX581">(581)</a>
</li>
<li>Sort avoidance <a href="perf113.html#IDX604">(604)</a>
</li>
<li>static IN predicates <a href="perf97.html#IDX587">(587)</a>
</li>
<li>transitive closure <a href="perf99.html#IDX591">(591)</a>
</li>
<li>views <a href="perf102.html#IDX593">(593)</a>
</li>
</ul>
</li>
</ul>
<strong><a href="#IDX0_4A">J</a></strong>
<ul>
<li>java.sql.ResultSet.getXXX methods <ul>
<li>performance implications of <a href="perf26.html#IDX417">(417)</a>
</li>
</ul>
</li>
<li>Join order <ul>
<li>analyzing <a href="perf36.html#IDX445">(445)</a>
</li>
<li>how optimizer chooses <a href="perf45.html#IDX484">(484)</a>
</li>
<li>performance implications of <a href="perf33.html#IDX433">(433)</a>, <a href="perf44.html#IDX472">(472)</a>
</li>
<li>rules of thumb <a href="perf44.html#IDX473">(473)</a>
</li>
</ul>
</li>
<li>Join strategies <a href="perf44.html#IDX474">(474)</a> 
<ul>
<li>how optimizer chooses <a href="perf45.html#IDX485">(485)</a>
</li>
</ul>
</li>
<li>Joins <ul>
<li>optimizability of <a href="perf43.html#IDX467">(467)</a>
</li>
<li>performance factors <a href="perf44.html#IDX471">(471)</a>
</li>
</ul>
</li>
</ul>
<strong><a href="#IDX0_4C">L</a></strong>
<ul>
<li>Language transformations for performance <a href="perf93.html#IDX572">(572)</a>
</li>
<li>Large database pages <ul>
<li>requirement for more memory <a href="perf24.html#IDX416">(416)</a>
</li>
</ul>
</li>
<li>LDAP <ul>
<li>configuring <a href="perf64.html#IDX514">(514)</a>, <a href="perf65.html#IDX516">(516)</a>, <a href="perf66.html#IDX518">(518)</a>, <a href="perf67.html#IDX520">(520)</a>, <a href="perf69.html#IDX524">(524)</a>
</li>
</ul>
</li>
<li>LIKE transformations <a href="perf96.html#IDX584">(584)</a>
</li>
<li>Lock escalation <a href="perf80.html#IDX548">(548)</a> 
<ul>
<li>at runtime (for transaction) <a href="perf47.html#IDX496">(496)</a>
</li>
<li>by user <a href="perf48.html#IDX498">(498)</a>
</li>
<li>chosen by optimizer <a href="perf45.html#IDX489">(489)</a>
</li>
<li>threshold <a href="perf45.html#IDX491">(491)</a>
</li>
</ul>
</li>
<li>Lock granularity <ul>
<li>how optimizer chooses <a href="perf45.html#IDX488">(488)</a>
</li>
</ul>
</li>
<li>LOCK TABLE statement <a href="perf48.html#IDX497">(497)</a>
</li>
<li>Locking <ul>
<li>performance implications of <a href="perf46.html#IDX495">(495)</a>
</li>
</ul>
</li>
<li>Locks <ul>
<li>monitoring <a href="perf81.html#IDX550">(550)</a>
</li>
</ul>
</li>
<li>LONGVARBINARY <ul>
<li>java.sql type converted to VARCHAR FOR BIT DATA when retrieved <a href="perf26.html#IDX419">(419)</a>
</li>
</ul>
</li>
<li>LONGVARCHAR <ul>
<li>java.sql type converted to VARCHAR when retrieved <a href="perf26.html#IDX420">(420)</a>
</li>
</ul>
</li>
</ul>
<strong><a href="#IDX0_4D">M</a></strong>
<ul>
<li>Matching index scans <ul>
<li>definition <a href="perf43.html#IDX461">(461)</a>
</li>
</ul>
</li>
<li>MAX() optimization <a href="perf51.html#IDX500">(500)</a>
</li>
<li>Memory <ul>
<li>allocating more memory to an application <a href="perf24.html#IDX415">(415)</a>
</li>
</ul>
</li>
<li>MIN() optimization <a href="perf51.html#IDX499">(499)</a>
</li>
</ul>
<strong><a href="#IDX0_4E">N</a></strong>
<ul>
<li>Nested loop join strategy <a href="perf44.html#IDX475">(475)</a>
</li>
</ul>
<strong><a href="#IDX0_4F">O</a></strong>
<ul>
<li>Optimizable <ul>
<li>definition <a href="perf43.html#IDX462">(462)</a>, <a href="perf93.html#IDX577">(577)</a>
</li>
</ul>
</li>
<li>Optimizable equijoins <ul>
<li>definition <a href="perf44.html#IDX478">(478)</a>
</li>
</ul>
</li>
<li>Optimizable operators <a href="perf43.html#IDX464">(464)</a>
</li>
<li>Optimization <a href="perf42.html#IDX453">(453)</a> 
<ul>
<li>requirements for <a href="perf43.html#IDX463">(463)</a>
</li>
</ul>
</li>
<li>Optimizer <ul>
<li>decisions made by <a href="perf45.html#IDX481">(481)</a>
</li>
<li>description <a href="perf42.html#IDX456">(456)</a>
</li>
</ul>
</li>
<li>OR transformations <a href="perf98.html#IDX588">(588)</a>
</li>
<li>ORDER BY <ul>
<li>cost-based avoidance of <a href="perf45.html#IDX487">(487)</a>
</li>
</ul>
</li>
</ul>
<strong><a href="#IDX0_50">P</a></strong>
<ul>
<li>Page cache size <ul>
<li>configuring <a href="perf85.html#IDX558">(558)</a>
</li>
</ul>
</li>
<li>Page size <ul>
<li>configuring <a href="perf87.html#IDX562">(562)</a>
</li>
<li>performance implications of <a href="perf24.html#IDX413">(413)</a>
</li>
<li>performance trade-offs of large pages <a href="perf24.html#IDX414">(414)</a>
</li>
</ul>
</li>
<li>Performance <ul>
<li>key issues <a href="perf32.html#IDX428">(428)</a>
</li>
</ul>
</li>
<li>Performance of statements <ul>
<li>analyzing <a href="perf37.html#IDX448">(448)</a>
</li>
</ul>
</li>
<li>Predicates <ul>
<li>definition <a href="perf93.html#IDX578">(578)</a>
</li>
<li>directly optimizable <a href="perf43.html#IDX460">(460)</a>
</li>
<li>indirectly optimizable <a href="perf43.html#IDX465">(465)</a>
</li>
<li>pushed down into views <a href="perf104.html#IDX595">(595)</a>
</li>
</ul>
</li>
<li>Prepared statements <ul>
<li>performance benefits of <a href="perf34.html#IDX439">(439)</a>
</li>
</ul>
</li>
<li>Properties <ul>
<li>conglomerate-specific scope <a href="perf09.html#IDX385">(385)</a>
</li>
<li>database-wide scope <a href="perf09.html#IDX384">(384)</a>
</li>
<li>dynamic versus static <a href="perf12.html#IDX392">(392)</a>
</li>
<li>implications of having various ways to set <a href="perf18.html#IDX408">(408)</a>
</li>
<li>in client/server mode <a href="perf16.html#IDX407">(407)</a>
</li>
<li>persistence of <a href="perf10.html#IDX386">(386)</a>
</li>
<li>precedence of <a href="perf11.html#IDX387">(387)</a>
</li>
<li>scope of <a href="perf09.html#IDX382">(382)</a>
</li>
<li>setting using a Properties object <a href="perf14.html#IDX398">(398)</a>
</li>
<li>system-wide scope <a href="perf09.html#IDX383">(383)</a>, <a href="perf14.html#IDX396">(396)</a>
</li>
</ul>
</li>
</ul>
<strong><a href="#IDX0_51">Q</a></strong>
<ul>
<li>Qualifiers <ul>
<li>in matching index scans <a href="perf43.html#IDX469">(469)</a>
</li>
</ul>
</li>
<li>Query optimization <a href="perf42.html#IDX454">(454)</a>
</li>
</ul>
<strong><a href="#IDX0_52">R</a></strong>
<ul>
<li>Reserving space on a page <a href="perf86.html#IDX560">(560)</a>
</li>
<li>Row counts <ul>
<li>when updated <a href="perf54.html#IDX504">(504)</a>
</li>
</ul>
</li>
<li>RunTimeStatistics <ul>
<li>overview <a href="perf38.html#IDX449">(449)</a>
</li>
<li>using <a href="perf39.html#IDX450">(450)</a>
</li>
</ul>
</li>
</ul>
<strong><a href="#IDX0_53">S</a></strong>
<ul>
<li>Sargable <ul>
<li>definition <a href="perf93.html#IDX579">(579)</a>
</li>
</ul>
</li>
<li>Selectivity <ul>
<li>definition <a href="perf55.html#IDX506">(506)</a>
</li>
<li>from cardinality statistics <a href="perf56.html#IDX508">(508)</a>
</li>
<li>hard-wired assumptions <a href="perf56.html#IDX509">(509)</a>
</li>
<li>how it is determined <a href="perf56.html#IDX507">(507)</a>
</li>
</ul>
</li>
<li>Shutdown <ul>
<li>performance benefits of <a href="perf29.html#IDX424">(424)</a>
</li>
</ul>
</li>
<li>Simple column reference <ul>
<li>definition <a href="perf93.html#IDX580">(580)</a>
</li>
</ul>
</li>
<li>Sort avoidance <a href="perf45.html#IDX486">(486)</a>, <a href="perf113.html#IDX603">(603)</a>
</li>
<li>Statement cache <ul>
<li>performance benefits of <a href="perf34.html#IDX440">(440)</a>
</li>
</ul>
</li>
<li>Statement execution <ul>
<li>analyzing <a href="perf36.html#IDX443">(443)</a>
</li>
<li>debugging <a href="perf77.html#IDX541">(541)</a>
</li>
</ul>
</li>
<li>Statement execution plan <a href="perf40.html#IDX452">(452)</a>
</li>
<li>Statements <ul>
<li>debugging <a href="perf77.html#IDX542">(542)</a>
</li>
<li>when they are optimizable <a href="perf43.html#IDX459">(459)</a>
</li>
</ul>
</li>
<li>Static IN transformations <a href="perf97.html#IDX586">(586)</a>
</li>
<li>Static properties <a href="perf12.html#IDX390">(390)</a>
</li>
<li>Statistics <a href="perf52.html#IDX501">(501)</a>
</li>
<li>Statistics timing <ul>
<li>use of <a href="perf40.html#IDX451">(451)</a>
</li>
</ul>
</li>
<li>Subqueries <ul>
<li>elimination of DISTINCT in IN, ANY, and EXISTS subqueries <a href="perf110.html#IDX601">(601)</a>
</li>
<li>flattening of <a href="perf107.html#IDX598">(598)</a>
</li>
<li>flattening of to an EXISTS join <a href="perf108.html#IDX599">(599)</a>
</li>
<li>materialization of <a href="perf106.html#IDX597">(597)</a>
</li>
<li>processing and transformations of <a href="perf105.html#IDX596">(596)</a>
</li>
</ul>
</li>
<li>SYSCS_UTIL.SYSCS_GET_DATABASE_PROPERTY <a href="perf15.html#IDX406">(406)</a>
</li>
<li>SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY <a href="perf15.html#IDX404">(404)</a>
</li>
<li>System properties <ul>
<li>setting in a Properties object <a href="perf14.html#IDX399">(399)</a>
</li>
<li>setting on command line <a href="perf14.html#IDX397">(397)</a>
</li>
</ul>
</li>
<li>System-wide properties <ul>
<li>setting <a href="perf14.html#IDX401">(401)</a>
</li>
</ul>
</li>
</ul>
<strong><a href="#IDX0_54">T</a></strong>
<ul>
<li>Table-level locking <ul>
<li>forcing for a specific table at creation time <a href="perf45.html#IDX490">(490)</a>
</li>
</ul>
</li>
<li>Table row counts <a href="perf54.html#IDX503">(503)</a>
</li>
<li>tmp directory <ul>
<li>setting location for <a href="perf88.html#IDX564">(564)</a>
</li>
</ul>
</li>
<li>Transitive closure <a href="perf99.html#IDX590">(590)</a>
</li>
</ul>
<strong><a href="#IDX0_55">U</a></strong>
<ul>
<li>UNION <ul>
<li>avoiding ordering during <a href="perf116.html#IDX607">(607)</a>
</li>
</ul>
</li>
<li>User authentication <ul>
<li>turning on <a href="perf70.html#IDX528">(528)</a>
</li>
</ul>
</li>
<li>User authorization <ul>
<li>configuring <a href="perf71.html#IDX530">(530)</a>, <a href="perf73.html#IDX533">(533)</a>, <a href="perf75.html#IDX537">(537)</a>
</li>
</ul>
</li>
<li>Users <ul>
<li>creating <a href="perf92.html#IDX571">(571)</a>
</li>
</ul>
</li>
</ul>
<strong><a href="#IDX0_56">V</a></strong>
<ul>
<li>View flattening <a href="perf103.html#IDX594">(594)</a>
</li>
<li>View transformations <a href="perf102.html#IDX592">(592)</a>
</li>
</ul>
<hr>
<a href="perf120.html">Previous Page</a>
<br>
<a href="perf02.html#ToC">Table of Contents</a>
<br>
<a href="#HDRINDEX_START">Index</a>
</div>
<div class="attribution"></div>
</div>
</td><td width="10"><img width="10" height="1" alt="" src="../../skin/images/spacer.gif" class="spacer"></td>
</tr>
<!--================= end Content==================-->
</table>
</td>
</tr>
</table>
<!--================= end Menu, NavBar, Content ==================-->
<!--================= start Footer ==================-->
<table summary="footer" cellspacing="0" cellpadding="0" width="100%" border="0">
<tr>
<td colspan="2" height="1" bgcolor="#4C6C8F"><img height="1" width="1" alt="" src="../../skin/images/spacer.gif" class="spacer"><a href="../../skin/images/label.gif"></a><a href="../../skin/images/page.gif"></a><a href="../../skin/images/chapter.gif"></a><a href="../../skin/images/chapter_open.gif"></a><a href="../../skin/images/current.gif"></a><a href="/favicon.ico"></a></td>
</tr>
<tr>
<td colspan="2" bgcolor="#CFDCED" class="copyright" align="center"><font size="2" face="Arial, Helvetica, Sans-Serif">Copyright &copy;
          2004&nbsp;Apache Software Foundation All rights reserved.<script type="text/javascript" language="JavaScript"><!--
              document.write(" - "+"Last Published: " + document.lastModified);
            //  --></script></font></td>
</tr>
<tr>
<td colspan="2" align="left" bgcolor="#CFDCED" class="logos"></td>
</tr>
</table>
<!--================= end Footer ==================-->
</body>
</html>
